﻿CREATE TABLE [dbo].[CIMUserInfo]
(
[aid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[cname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[workplace] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL,
[livein] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL,
[identcard] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[idoverdate] [datetime] NULL,
[hid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[hvalue] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[wage] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[rpr] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL,
[mpm] [money] NULL,
[ocash1] [money] NULL,
[ocash2] [money] NULL,
[ocash3] [money] NULL,
[oftel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[htel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[mphone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[othercon] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL,
[yname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[yworkplace] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL,
[yidentcard] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[yrpr] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL,
[yoftel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[yhtel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[ymphone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[yothercon] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL,
[cbirthday] [datetime] NULL,
[cbirthtype] [bit] NULL,
[csex] [bit] NULL,
[ybirthday] [datetime] NULL,
[ybirthtype] [bit] NULL,
[ysex] [bit] NULL,
[PayAccount] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]


